Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	200000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	257.5 MiB
Average record size in memory	1.3 KiB

Variable types

Text	6
Categorical	13
Numeric	3
DateTime	2

Alerts

`Is_Fraud` is highly overall correlated with `Transaction_Amount` and 1 other fields	High correlation
`Transaction_Amount` is highly overall correlated with `Is_Fraud`	High correlation
`Transaction_Location` is highly overall correlated with `Is_Fraud`	High correlation
`Is_Fraud` is highly imbalanced (63.4%)	Imbalance
`Customer_ID` has unique values	Unique
`Customer_Name` has unique values	Unique
`Transaction_ID` has unique values	Unique
`Transaction_Date` has unique values	Unique

Reproduction

Analysis started	2025-02-27 02:21:27.953744
Analysis finished	2025-02-27 02:22:17.490265
Duration	49.54 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Customer_ID
Text

Unique

Distinct	200000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	12.8 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2000000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	200000 ?
Unique (%)	100.0%

Sample

1st row	CUST000001
2nd row	CUST000002
3rd row	CUST000003
4th row	CUST000004
5th row	CUST000005

Value	Count	Frequency (%)
cust199985	1	< 0.1%
cust199986	1	< 0.1%
cust199987	1	< 0.1%
cust199988	1	< 0.1%
cust199989	1	< 0.1%
cust199990	1	< 0.1%
cust199991	1	< 0.1%
cust199992	1	< 0.1%
cust199993	1	< 0.1%
cust199994	1	< 0.1%
Other values (199990)	199990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
C	200000	10.0%
U	200000	10.0%
S	200000	10.0%
T	200000	10.0%
1	200000	10.0%
0	199999	10.0%
2	100001	5.0%
9	100000	5.0%
4	100000	5.0%
8	100000	5.0%
Other values (4)	400000	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2000000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	200000	10.0%
U	200000	10.0%
S	200000	10.0%
T	200000	10.0%
1	200000	10.0%
0	199999	10.0%
2	100001	5.0%
9	100000	5.0%
4	100000	5.0%
8	100000	5.0%
Other values (4)	400000	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2000000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	200000	10.0%
U	200000	10.0%
S	200000	10.0%
T	200000	10.0%
1	200000	10.0%
0	199999	10.0%
2	100001	5.0%
9	100000	5.0%
4	100000	5.0%
8	100000	5.0%
Other values (4)	400000	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2000000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	200000	10.0%
U	200000	10.0%
S	200000	10.0%
T	200000	10.0%
1	200000	10.0%
0	199999	10.0%
2	100001	5.0%
9	100000	5.0%
4	100000	5.0%
8	100000	5.0%
Other values (4)	400000	20.0%

Customer_Name
Text

Unique

Distinct	200000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	13.6 MiB

Length

Max length	15
Median length	15
Mean length	14.444475
Min length	10

Characters and Unicode

Total characters	2888895
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	200000 ?
Unique (%)	100.0%

Sample

1st row	Customer_1
2nd row	Customer_2
3rd row	Customer_3
4th row	Customer_4
5th row	Customer_5

Value	Count	Frequency (%)
customer_199985	1	< 0.1%
customer_199986	1	< 0.1%
customer_199987	1	< 0.1%
customer_199988	1	< 0.1%
customer_199989	1	< 0.1%
customer_199990	1	< 0.1%
customer_199991	1	< 0.1%
customer_199992	1	< 0.1%
customer_199993	1	< 0.1%
customer_199994	1	< 0.1%
Other values (199990)	199990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
C	200000	6.9%
u	200000	6.9%
s	200000	6.9%
t	200000	6.9%
o	200000	6.9%
m	200000	6.9%
e	200000	6.9%
r	200000	6.9%
_	200000	6.9%
1	200000	6.9%
Other values (9)	888895	30.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2888895	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	200000	6.9%
u	200000	6.9%
s	200000	6.9%
t	200000	6.9%
o	200000	6.9%
m	200000	6.9%
e	200000	6.9%
r	200000	6.9%
_	200000	6.9%
1	200000	6.9%
Other values (9)	888895	30.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2888895	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	200000	6.9%
u	200000	6.9%
s	200000	6.9%
t	200000	6.9%
o	200000	6.9%
m	200000	6.9%
e	200000	6.9%
r	200000	6.9%
_	200000	6.9%
1	200000	6.9%
Other values (9)	888895	30.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2888895	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	200000	6.9%
u	200000	6.9%
s	200000	6.9%
t	200000	6.9%
o	200000	6.9%
m	200000	6.9%
e	200000	6.9%
r	200000	6.9%
_	200000	6.9%
1	200000	6.9%
Other values (9)	888895	30.8%

Gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.8 MiB

Female	100232
Male	99768

Length

Max length	6
Median length	6
Mean length	5.00232
Min length	4

Characters and Unicode

Total characters	1000464
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Female
3rd row	Female
4th row	Female
5th row	Male

Common Values

Value	Count	Frequency (%)
Female	100232	50.1%
Male	99768	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	100232	50.1%
male	99768	49.9%

Most occurring characters

Value	Count	Frequency (%)
e	300232	30.0%
a	200000	20.0%
l	200000	20.0%
F	100232	10.0%
m	100232	10.0%
M	99768	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1000464	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	300232	30.0%
a	200000	20.0%
l	200000	20.0%
F	100232	10.0%
m	100232	10.0%
M	99768	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1000464	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	300232	30.0%
a	200000	20.0%
l	200000	20.0%
F	100232	10.0%
m	100232	10.0%
M	99768	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1000464	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	300232	30.0%
a	200000	20.0%
l	200000	20.0%
F	100232	10.0%
m	100232	10.0%
M	99768	10.0%

Age
Real number (ℝ)

Distinct	62
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.46971

Minimum	18
Maximum	79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	18
5-th percentile	21
Q1	33
median	48
Q3	64
95-th percentile	76
Maximum	79
Range	61
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	17.896964
Coefficient of variation (CV)	0.36924017
Kurtosis	-1.1997223
Mean	48.46971
Median Absolute Deviation (MAD)	15
Skewness	0.0007206454
Sum	9693942
Variance	320.30132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
57	3343	1.7%
40	3341	1.7%
34	3316	1.7%
22	3314	1.7%
62	3313	1.7%
49	3293	1.6%
25	3286	1.6%
44	3282	1.6%
73	3279	1.6%
70	3273	1.6%
Other values (52)	166960	83.5%

Value	Count	Frequency (%)
18	3261	1.6%
19	3265	1.6%
20	3264	1.6%
21	3184	1.6%
22	3314	1.7%
23	3257	1.6%
24	3162	1.6%
25	3286	1.6%
26	3202	1.6%
27	3188	1.6%

Value	Count	Frequency (%)
79	3213	1.6%
78	3216	1.6%
77	3173	1.6%
76	3264	1.6%
75	3239	1.6%
74	3112	1.6%
73	3279	1.6%
72	3213	1.6%
71	3195	1.6%
70	3273	1.6%

State
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

FL	28648
OH	28631
NY	28613
TX	28549
CA	28538
Other values (2)	57021

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	400000
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CA
2nd row	FL
3rd row	PA
4th row	NY
5th row	OH

Common Values

Value	Count	Frequency (%)
FL	28648	14.3%
OH	28631	14.3%
NY	28613	14.3%
TX	28549	14.3%
CA	28538	14.3%
IL	28525	14.3%
PA	28496	14.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fl	28648	14.3%
oh	28631	14.3%
ny	28613	14.3%
tx	28549	14.3%
ca	28538	14.3%
il	28525	14.3%
pa	28496	14.2%

Most occurring characters

Value	Count	Frequency (%)
L	57173	14.3%
A	57034	14.3%
F	28648	7.2%
O	28631	7.2%
H	28631	7.2%
N	28613	7.2%
Y	28613	7.2%
T	28549	7.1%
X	28549	7.1%
C	28538	7.1%
Other values (2)	57021	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	57173	14.3%
A	57034	14.3%
F	28648	7.2%
O	28631	7.2%
H	28631	7.2%
N	28613	7.2%
Y	28613	7.2%
T	28549	7.1%
X	28549	7.1%
C	28538	7.1%
Other values (2)	57021	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	57173	14.3%
A	57034	14.3%
F	28648	7.2%
O	28631	7.2%
H	28631	7.2%
N	28613	7.2%
Y	28613	7.2%
T	28549	7.1%
X	28549	7.1%
C	28538	7.1%
Other values (2)	57021	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	57173	14.3%
A	57034	14.3%
F	28648	7.2%
O	28631	7.2%
H	28631	7.2%
N	28613	7.2%
Y	28613	7.2%
T	28549	7.1%
X	28549	7.1%
C	28538	7.1%
Other values (2)	57021	14.3%

City
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.4 MiB

Chicago	28762
Houston	28640
Philadelphia	28583
Dallas	28578
Los Angeles	28507
Other values (2)	56930

Length

Max length	12
Median length	8
Mean length	7.999245
Min length	5

Characters and Unicode

Total characters	1599849
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Los Angeles
2nd row	New York
3rd row	Dallas
4th row	Chicago
5th row	Philadelphia

Common Values

Value	Count	Frequency (%)
Chicago	28762	14.4%
Houston	28640	14.3%
Philadelphia	28583	14.3%
Dallas	28578	14.3%
Los Angeles	28507	14.3%
Miami	28482	14.2%
New York	28448	14.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	28762	11.2%
houston	28640	11.1%
philadelphia	28583	11.1%
dallas	28578	11.1%
los	28507	11.1%
angeles	28507	11.1%
miami	28482	11.1%
new	28448	11.1%
york	28448	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	171566	10.7%
o	142997	8.9%
i	142892	8.9%
l	142829	8.9%
s	114232	7.1%
e	114045	7.1%
h	85928	5.4%
g	57269	3.6%
n	57147	3.6%
	56955	3.6%
Other values (18)	513989	32.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1599849	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	171566	10.7%
o	142997	8.9%
i	142892	8.9%
l	142829	8.9%
s	114232	7.1%
e	114045	7.1%
h	85928	5.4%
g	57269	3.6%
n	57147	3.6%
	56955	3.6%
Other values (18)	513989	32.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1599849	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	171566	10.7%
o	142997	8.9%
i	142892	8.9%
l	142829	8.9%
s	114232	7.1%
e	114045	7.1%
h	85928	5.4%
g	57269	3.6%
n	57147	3.6%
	56955	3.6%
Other values (18)	513989	32.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1599849	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	171566	10.7%
o	142997	8.9%
i	142892	8.9%
l	142829	8.9%
s	114232	7.1%
e	114045	7.1%
h	85928	5.4%
g	57269	3.6%
n	57147	3.6%
	56955	3.6%
Other values (18)	513989	32.1%

Bank_Branch
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.4 MiB

Branch A	50274
Branch C	50027
Branch D	49850
Branch B	49849

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	1600000
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Branch B
2nd row	Branch C
3rd row	Branch A
4th row	Branch A
5th row	Branch B

Common Values

Value	Count	Frequency (%)
Branch A	50274	25.1%
Branch C	50027	25.0%
Branch D	49850	24.9%
Branch B	49849	24.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
branch	200000	50.0%
a	50274	12.6%
c	50027	12.5%
d	49850	12.5%
b	49849	12.5%

Most occurring characters

Value	Count	Frequency (%)
B	249849	15.6%
r	200000	12.5%
a	200000	12.5%
n	200000	12.5%
c	200000	12.5%
h	200000	12.5%
	200000	12.5%
A	50274	3.1%
C	50027	3.1%
D	49850	3.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1600000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	249849	15.6%
r	200000	12.5%
a	200000	12.5%
n	200000	12.5%
c	200000	12.5%
h	200000	12.5%
	200000	12.5%
A	50274	3.1%
C	50027	3.1%
D	49850	3.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1600000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	249849	15.6%
r	200000	12.5%
a	200000	12.5%
n	200000	12.5%
c	200000	12.5%
h	200000	12.5%
	200000	12.5%
A	50274	3.1%
C	50027	3.1%
D	49850	3.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1600000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	249849	15.6%
r	200000	12.5%
a	200000	12.5%
n	200000	12.5%
c	200000	12.5%
h	200000	12.5%
	200000	12.5%
A	50274	3.1%
C	50027	3.1%
D	49850	3.1%

Account_Type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Savings	119763
Checking	60167
Business	20070

Length

Max length	8
Median length	7
Mean length	7.401185
Min length	7

Characters and Unicode

Total characters	1480237
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Checking
2nd row	Savings
3rd row	Savings
4th row	Savings
5th row	Savings

Common Values

Value	Count	Frequency (%)
Savings	119763	59.9%
Checking	60167	30.1%
Business	20070	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
savings	119763	59.9%
checking	60167	30.1%
business	20070	10.0%

Most occurring characters

Value	Count	Frequency (%)
n	200000	13.5%
i	200000	13.5%
s	179973	12.2%
g	179930	12.2%
a	119763	8.1%
S	119763	8.1%
v	119763	8.1%
e	80237	5.4%
C	60167	4.1%
h	60167	4.1%
Other values (4)	160474	10.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1480237	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	200000	13.5%
i	200000	13.5%
s	179973	12.2%
g	179930	12.2%
a	119763	8.1%
S	119763	8.1%
v	119763	8.1%
e	80237	5.4%
C	60167	4.1%
h	60167	4.1%
Other values (4)	160474	10.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1480237	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	200000	13.5%
i	200000	13.5%
s	179973	12.2%
g	179930	12.2%
a	119763	8.1%
S	119763	8.1%
v	119763	8.1%
e	80237	5.4%
C	60167	4.1%
h	60167	4.1%
Other values (4)	160474	10.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1480237	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	200000	13.5%
i	200000	13.5%
s	179973	12.2%
g	179930	12.2%
a	119763	8.1%
S	119763	8.1%
v	119763	8.1%
e	80237	5.4%
C	60167	4.1%
h	60167	4.1%
Other values (4)	160474	10.8%

Transaction_ID
Text

Unique

Distinct	200000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	13.2 MiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	2400000
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	200000 ?
Unique (%)	100.0%

Sample

1st row	TXN000000001
2nd row	TXN000000002
3rd row	TXN000000003
4th row	TXN000000004
5th row	TXN000000005

Value	Count	Frequency (%)
txn000199985	1	< 0.1%
txn000199986	1	< 0.1%
txn000199987	1	< 0.1%
txn000199988	1	< 0.1%
txn000199989	1	< 0.1%
txn000199990	1	< 0.1%
txn000199991	1	< 0.1%
txn000199992	1	< 0.1%
txn000199993	1	< 0.1%
txn000199994	1	< 0.1%
Other values (199990)	199990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	799999	33.3%
T	200000	8.3%
X	200000	8.3%
N	200000	8.3%
1	200000	8.3%
2	100001	4.2%
9	100000	4.2%
4	100000	4.2%
8	100000	4.2%
3	100000	4.2%
Other values (3)	300000	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2400000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	799999	33.3%
T	200000	8.3%
X	200000	8.3%
N	200000	8.3%
1	200000	8.3%
2	100001	4.2%
9	100000	4.2%
4	100000	4.2%
8	100000	4.2%
3	100000	4.2%
Other values (3)	300000	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2400000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	799999	33.3%
T	200000	8.3%
X	200000	8.3%
N	200000	8.3%
1	200000	8.3%
2	100001	4.2%
9	100000	4.2%
4	100000	4.2%
8	100000	4.2%
3	100000	4.2%
Other values (3)	300000	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2400000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	799999	33.3%
T	200000	8.3%
X	200000	8.3%
N	200000	8.3%
1	200000	8.3%
2	100001	4.2%
9	100000	4.2%
4	100000	4.2%
8	100000	4.2%
3	100000	4.2%
Other values (3)	300000	12.5%

Transaction_Date
Date

Unique

Distinct	200000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2023-01-01 00:00:00
Maximum	2023-05-19 21:19:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Transaction_Time
Date

Distinct	1440
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2025-02-26 00:00:00
Maximum	2025-02-26 23:59:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Transaction_Amount
Real number (ℝ)

High correlation

Distinct	185461
Distinct (%)	92.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	105.03262

Minimum	5
Maximum	1897.8694
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	5
5-th percentile	5
Q1	31.508303
median	52.831014
Q3	75.871259
95-th percentile	630.38974
Maximum	1897.8694
Range	1892.8694
Interquartile range (IQR)	44.362956

Descriptive statistics

Standard deviation	210.89496
Coefficient of variation (CV)	2.0078996
Kurtosis	15.452889
Mean	105.03262
Median Absolute Deviation (MAD)	22.128433
Skewness	3.9231113
Sum	21006524
Variance	44476.685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	12341	6.2%
500	2200	1.1%
83.03462405	1	< 0.1%
51.52127843	1	< 0.1%
74.89715577	1	< 0.1%
642.9258356	1	< 0.1%
998.7898949	1	< 0.1%
772.0799109	1	< 0.1%
974.7373898	1	< 0.1%
990.3640153	1	< 0.1%
Other values (185451)	185451	92.7%

Value	Count	Frequency (%)
5	12341	6.2%
5.000461214	1	< 0.1%
5.000605258	1	< 0.1%
5.002293223	1	< 0.1%
5.006229507	1	< 0.1%
5.007303913	1	< 0.1%
5.008446896	1	< 0.1%
5.010560559	1	< 0.1%
5.010751688	1	< 0.1%
5.010990974	1	< 0.1%

Value	Count	Frequency (%)
1897.869419	1	< 0.1%
1834.433622	1	< 0.1%
1820.311895	1	< 0.1%
1809.659966	1	< 0.1%
1797.684375	1	< 0.1%
1787.498	1	< 0.1%
1779.59386	1	< 0.1%
1772.913102	1	< 0.1%
1764.350422	1	< 0.1%
1760.67967	1	< 0.1%

Merchant_ID
Text

Distinct	999
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	12.9 MiB

Length

Max length	11
Median length	11
Mean length	10.89141
Min length	9

Characters and Unicode

Total characters	2178282
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MERCHANT839
2nd row	MERCHANT50
3rd row	MERCHANT453
4th row	MERCHANT231
5th row	MERCHANT664

Value	Count	Frequency (%)
merchant229	270	0.1%
merchant496	247	0.1%
merchant146	247	0.1%
merchant302	239	0.1%
merchant716	237	0.1%
merchant225	235	0.1%
merchant350	234	0.1%
merchant597	234	0.1%
merchant675	234	0.1%
merchant490	233	0.1%
Other values (989)	197590	98.8%

Most occurring characters

Value	Count	Frequency (%)
M	200000	9.2%
E	200000	9.2%
R	200000	9.2%
C	200000	9.2%
H	200000	9.2%
A	200000	9.2%
N	200000	9.2%
T	200000	9.2%
2	60436	2.8%
5	60320	2.8%
Other values (8)	457526	21.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2178282	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	200000	9.2%
E	200000	9.2%
R	200000	9.2%
C	200000	9.2%
H	200000	9.2%
A	200000	9.2%
N	200000	9.2%
T	200000	9.2%
2	60436	2.8%
5	60320	2.8%
Other values (8)	457526	21.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2178282	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	200000	9.2%
E	200000	9.2%
R	200000	9.2%
C	200000	9.2%
H	200000	9.2%
A	200000	9.2%
N	200000	9.2%
T	200000	9.2%
2	60436	2.8%
5	60320	2.8%
Other values (8)	457526	21.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2178282	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	200000	9.2%
E	200000	9.2%
R	200000	9.2%
C	200000	9.2%
H	200000	9.2%
A	200000	9.2%
N	200000	9.2%
T	200000	9.2%
2	60436	2.8%
5	60320	2.8%
Other values (8)	457526	21.0%

Transaction_Type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.1 MiB

Online	80142
POS	79974
ATM Withdrawal	39884

Length

Max length	14
Median length	6
Mean length	6.39575
Min length	3

Characters and Unicode

Total characters	1279150
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Online
2nd row	ATM Withdrawal
3rd row	ATM Withdrawal
4th row	ATM Withdrawal
5th row	Online

Common Values

Value	Count	Frequency (%)
Online	80142	40.1%
POS	79974	40.0%
ATM Withdrawal	39884	19.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
online	80142	33.4%
pos	79974	33.3%
atm	39884	16.6%
withdrawal	39884	16.6%

Most occurring characters

Value	Count	Frequency (%)
n	160284	12.5%
O	160116	12.5%
l	120026	9.4%
i	120026	9.4%
e	80142	6.3%
P	79974	6.3%
S	79974	6.3%
a	79768	6.2%
T	39884	3.1%
A	39884	3.1%
Other values (8)	319072	24.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1279150	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	160284	12.5%
O	160116	12.5%
l	120026	9.4%
i	120026	9.4%
e	80142	6.3%
P	79974	6.3%
S	79974	6.3%
a	79768	6.2%
T	39884	3.1%
A	39884	3.1%
Other values (8)	319072	24.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1279150	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	160284	12.5%
O	160116	12.5%
l	120026	9.4%
i	120026	9.4%
e	80142	6.3%
P	79974	6.3%
S	79974	6.3%
a	79768	6.2%
T	39884	3.1%
A	39884	3.1%
Other values (8)	319072	24.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1279150	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	160284	12.5%
O	160116	12.5%
l	120026	9.4%
i	120026	9.4%
e	80142	6.3%
P	79974	6.3%
S	79974	6.3%
a	79768	6.2%
T	39884	3.1%
A	39884	3.1%
Other values (8)	319072	24.9%

Merchant_Category
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.6 MiB

Travel	35929
Luxury	35605
Online Services	35545
Electronics	31180
Grocery	30962

Length

Max length	15
Median length	11
Mean length	8.841625
Min length	6

Characters and Unicode

Total characters	1768325
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Clothing
2nd row	Luxury
3rd row	Travel
4th row	Clothing
5th row	Electronics

Common Values

Value	Count	Frequency (%)
Travel	35929	18.0%
Luxury	35605	17.8%
Online Services	35545	17.8%
Electronics	31180	15.6%
Grocery	30962	15.5%
Clothing	30779	15.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
travel	35929	15.3%
luxury	35605	15.1%
online	35545	15.1%
services	35545	15.1%
electronics	31180	13.2%
grocery	30962	13.1%
clothing	30779	13.1%

Most occurring characters

Value	Count	Frequency (%)
e	204706	11.6%
r	200183	11.3%
l	133433	7.5%
n	133049	7.5%
i	133049	7.5%
c	128867	7.3%
o	92921	5.3%
v	71474	4.0%
u	71210	4.0%
s	66725	3.8%
Other values (14)	532708	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1768325	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	204706	11.6%
r	200183	11.3%
l	133433	7.5%
n	133049	7.5%
i	133049	7.5%
c	128867	7.3%
o	92921	5.3%
v	71474	4.0%
u	71210	4.0%
s	66725	3.8%
Other values (14)	532708	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1768325	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	204706	11.6%
r	200183	11.3%
l	133433	7.5%
n	133049	7.5%
i	133049	7.5%
c	128867	7.3%
o	92921	5.3%
v	71474	4.0%
u	71210	4.0%
s	66725	3.8%
Other values (14)	532708	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1768325	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	204706	11.6%
r	200183	11.3%
l	133433	7.5%
n	133049	7.5%
i	133049	7.5%
c	128867	7.3%
o	92921	5.3%
v	71474	4.0%
u	71210	4.0%
s	66725	3.8%
Other values (14)	532708	30.1%

Account_Balance
Real number (ℝ)

Distinct	198734
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4995.8658

Minimum	0
Maximum	13631.898
Zeros	1267
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1690.519
Q1	3646.6209
median	4987.4005
Q3	6343.9981
95-th percentile	8296.04
Maximum	13631.898
Range	13631.898
Interquartile range (IQR)	2697.3772

Descriptive statistics

Standard deviation	1990.9146
Coefficient of variation (CV)	0.39851242
Kurtosis	-0.11582181
Mean	4995.8658
Median Absolute Deviation (MAD)	1348.3527
Skewness	0.044220137
Sum	9.9917316 × 10⁸
Variance	3963740.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1267	0.6%
4070.596903	1	< 0.1%
4790.814115	1	< 0.1%
2799.823637	1	< 0.1%
3511.964463	1	< 0.1%
6325.143822	1	< 0.1%
4943.596395	1	< 0.1%
5517.654152	1	< 0.1%
6330.928087	1	< 0.1%
3392.716244	1	< 0.1%
Other values (198724)	198724	99.4%

Value	Count	Frequency (%)
0	1267	0.6%
0.002169337859	1	< 0.1%
0.4378865496	1	< 0.1%
2.004019109	1	< 0.1%
3.956628034	1	< 0.1%
4.046878393	1	< 0.1%
5.956477747	1	< 0.1%
6.417498548	1	< 0.1%
6.990873221	1	< 0.1%
6.991436561	1	< 0.1%

Value	Count	Frequency (%)
13631.89815	1	< 0.1%
13324.62493	1	< 0.1%
13305.5696	1	< 0.1%
13030.04863	1	< 0.1%
12991.81541	1	< 0.1%
12908.76152	1	< 0.1%
12879.6356	1	< 0.1%
12766.36252	1	< 0.1%
12732.06282	1	< 0.1%
12624.48431	1	< 0.1%

Transaction_Device
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Web	53687
ATM	53499
POS Terminal	46436
Mobile	46378

Length

Max length	12
Median length	3
Mean length	5.78529
Min length	3

Characters and Unicode

Total characters	1157058
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	POS Terminal
2nd row	Web
3rd row	POS Terminal
4th row	POS Terminal
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	53687	26.8%
ATM	53499	26.7%
POS Terminal	46436	23.2%
Mobile	46378	23.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
web	53687	21.8%
atm	53499	21.7%
pos	46436	18.8%
terminal	46436	18.8%
mobile	46378	18.8%

Most occurring characters

Value	Count	Frequency (%)
e	146501	12.7%
b	100065	8.6%
T	99935	8.6%
M	99877	8.6%
l	92814	8.0%
i	92814	8.0%
W	53687	4.6%
A	53499	4.6%
P	46436	4.0%
S	46436	4.0%
Other values (7)	324994	28.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1157058	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	146501	12.7%
b	100065	8.6%
T	99935	8.6%
M	99877	8.6%
l	92814	8.0%
i	92814	8.0%
W	53687	4.6%
A	53499	4.6%
P	46436	4.0%
S	46436	4.0%
Other values (7)	324994	28.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1157058	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	146501	12.7%
b	100065	8.6%
T	99935	8.6%
M	99877	8.6%
l	92814	8.0%
i	92814	8.0%
W	53687	4.6%
A	53499	4.6%
P	46436	4.0%
S	46436	4.0%
Other values (7)	324994	28.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1157058	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	146501	12.7%
b	100065	8.6%
T	99935	8.6%
M	99877	8.6%
l	92814	8.0%
i	92814	8.0%
W	53687	4.6%
A	53499	4.6%
P	46436	4.0%
S	46436	4.0%
Other values (7)	324994	28.1%

Transaction_Location
Categorical

High correlation

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.3 MiB

OH	26773
PA	26689
IL	26645
CA	26556
TX	26489
Other values (5)	66848

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	400000
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CA
2nd row	TX
3rd row	IL
4th row	CA
5th row	PA

Common Values

Value	Count	Frequency (%)
OH	26773	13.4%
PA	26689	13.3%
IL	26645	13.3%
CA	26556	13.3%
TX	26489	13.2%
FL	26434	13.2%
NY	26414	13.2%
Hi	4721	2.4%
Un	4641	2.3%
Of	4638	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
oh	26773	13.4%
pa	26689	13.3%
il	26645	13.3%
ca	26556	13.3%
tx	26489	13.2%
fl	26434	13.2%
ny	26414	13.2%
hi	4721	2.4%
un	4641	2.3%
of	4638	2.3%

Most occurring characters

Value	Count	Frequency (%)
A	53245	13.3%
L	53079	13.3%
H	31494	7.9%
O	31411	7.9%
P	26689	6.7%
I	26645	6.7%
C	26556	6.6%
T	26489	6.6%
X	26489	6.6%
F	26434	6.6%
Other values (6)	71469	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	53245	13.3%
L	53079	13.3%
H	31494	7.9%
O	31411	7.9%
P	26689	6.7%
I	26645	6.7%
C	26556	6.6%
T	26489	6.6%
X	26489	6.6%
F	26434	6.6%
Other values (6)	71469	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	53245	13.3%
L	53079	13.3%
H	31494	7.9%
O	31411	7.9%
P	26689	6.7%
I	26645	6.7%
C	26556	6.6%
T	26489	6.6%
X	26489	6.6%
F	26434	6.6%
Other values (6)	71469	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	400000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	53245	13.3%
L	53079	13.3%
H	31494	7.9%
O	31411	7.9%
P	26689	6.7%
I	26645	6.7%
C	26556	6.6%
T	26489	6.6%
X	26489	6.6%
F	26434	6.6%
Other values (6)	71469	17.9%

Device_Type
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.3 MiB

Windows PC	38104
ATM Machine	37942
Mac	31173
Android	31016
Linux	30969

Length

Max length	11
Median length	7
Mean length	7.24327
Min length	3

Characters and Unicode

Total characters	1448654
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Windows PC
2nd row	Android
3rd row	Windows PC
4th row	Windows PC
5th row	Linux

Common Values

Value	Count	Frequency (%)
Windows PC	38104	19.1%
ATM Machine	37942	19.0%
Mac	31173	15.6%
Android	31016	15.5%
Linux	30969	15.5%
iPhone	30796	15.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
windows	38104	13.8%
pc	38104	13.8%
atm	37942	13.7%
machine	37942	13.7%
mac	31173	11.3%
android	31016	11.2%
linux	30969	11.2%
iphone	30796	11.2%

Most occurring characters

Value	Count	Frequency (%)
i	168827	11.7%
n	168827	11.7%
M	107057	7.4%
d	100136	6.9%
o	99916	6.9%
	76046	5.2%
c	69115	4.8%
a	69115	4.8%
A	68958	4.8%
P	68900	4.8%
Other values (11)	451757	31.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1448654	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	168827	11.7%
n	168827	11.7%
M	107057	7.4%
d	100136	6.9%
o	99916	6.9%
	76046	5.2%
c	69115	4.8%
a	69115	4.8%
A	68958	4.8%
P	68900	4.8%
Other values (11)	451757	31.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1448654	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	168827	11.7%
n	168827	11.7%
M	107057	7.4%
d	100136	6.9%
o	99916	6.9%
	76046	5.2%
c	69115	4.8%
a	69115	4.8%
A	68958	4.8%
P	68900	4.8%
Other values (11)	451757	31.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1448654	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	168827	11.7%
n	168827	11.7%
M	107057	7.4%
d	100136	6.9%
o	99916	6.9%
	76046	5.2%
c	69115	4.8%
a	69115	4.8%
A	68958	4.8%
P	68900	4.8%
Other values (11)	451757	31.2%

Is_Fraud
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.1 MiB

0	186000
1	14000

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	200000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	186000	93.0%
1	14000	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	186000	93.0%
1	14000	7.0%

Most occurring characters

Value	Count	Frequency (%)
0	186000	93.0%
1	14000	7.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	200000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	186000	93.0%
1	14000	7.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	200000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	186000	93.0%
1	14000	7.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	200000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	186000	93.0%
1	14000	7.0%

Transaction_Currency
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.4 MiB

USD	160082
CAD	19978
GBP	10009
EUR	9931

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	600000
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	EUR
4th row	CAD
5th row	CAD

Common Values

Value	Count	Frequency (%)
USD	160082	80.0%
CAD	19978	10.0%
GBP	10009	5.0%
EUR	9931	5.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	160082	80.0%
cad	19978	10.0%
gbp	10009	5.0%
eur	9931	5.0%

Most occurring characters

Value	Count	Frequency (%)
D	180060	30.0%
U	170013	28.3%
S	160082	26.7%
C	19978	3.3%
A	19978	3.3%
G	10009	1.7%
B	10009	1.7%
P	10009	1.7%
E	9931	1.7%
R	9931	1.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	600000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	180060	30.0%
U	170013	28.3%
S	160082	26.7%
C	19978	3.3%
A	19978	3.3%
G	10009	1.7%
B	10009	1.7%
P	10009	1.7%
E	9931	1.7%
R	9931	1.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	600000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	180060	30.0%
U	170013	28.3%
S	160082	26.7%
C	19978	3.3%
A	19978	3.3%
G	10009	1.7%
B	10009	1.7%
P	10009	1.7%
E	9931	1.7%
R	9931	1.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	600000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	180060	30.0%
U	170013	28.3%
S	160082	26.7%
C	19978	3.3%
A	19978	3.3%
G	10009	1.7%
B	10009	1.7%
P	10009	1.7%
E	9931	1.7%
R	9931	1.7%

Customer_Contact
Text

Distinct	197504
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Memory size	13.0 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	2200000
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	195021 ?
Unique (%)	97.5%

Sample

1st row	+1-240-2997
2nd row	+1-641-1940
3rd row	+1-685-4317
4th row	+1-650-5207
5th row	+1-995-5816

Value	Count	Frequency (%)
1-349-4074	3	< 0.1%
1-622-6452	3	< 0.1%
1-973-1511	3	< 0.1%
1-593-3288	3	< 0.1%
1-245-1873	3	< 0.1%
1-959-4796	3	< 0.1%
1-560-9175	3	< 0.1%
1-438-3247	3	< 0.1%
1-112-1104	3	< 0.1%
1-911-8493	3	< 0.1%
Other values (197494)	199970	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	400000	18.2%
1	345174	15.7%
+	200000	9.1%
5	144627	6.6%
7	144595	6.6%
3	144571	6.6%
2	144533	6.6%
8	144338	6.6%
6	144288	6.6%
4	143979	6.5%
Other values (2)	243895	11.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2200000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	400000	18.2%
1	345174	15.7%
+	200000	9.1%
5	144627	6.6%
7	144595	6.6%
3	144571	6.6%
2	144533	6.6%
8	144338	6.6%
6	144288	6.6%
4	143979	6.5%
Other values (2)	243895	11.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2200000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	400000	18.2%
1	345174	15.7%
+	200000	9.1%
5	144627	6.6%
7	144595	6.6%
3	144571	6.6%
2	144533	6.6%
8	144338	6.6%
6	144288	6.6%
4	143979	6.5%
Other values (2)	243895	11.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2200000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	400000	18.2%
1	345174	15.7%
+	200000	9.1%
5	144627	6.6%
7	144595	6.6%
3	144571	6.6%
2	144533	6.6%
8	144338	6.6%
6	144288	6.6%
4	143979	6.5%
Other values (2)	243895	11.1%

Transaction_Description
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.4 MiB

Refund	40205
Gift	40047
Bill Payment	40039
Subscription	39916
Payment	39793

Length

Max length	12
Median length	7
Mean length	8.197145
Min length	4

Characters and Unicode

Total characters	1639429
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gift
2nd row	Payment
3rd row	Subscription
4th row	Subscription
5th row	Gift

Common Values

Value	Count	Frequency (%)
Refund	40205	20.1%
Gift	40047	20.0%
Bill Payment	40039	20.0%
Subscription	39916	20.0%
Payment	39793	19.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
payment	79832	33.3%
refund	40205	16.7%
gift	40047	16.7%
bill	40039	16.7%
subscription	39916	16.6%

Most occurring characters

Value	Count	Frequency (%)
n	159953	9.8%
i	159918	9.8%
t	159795	9.7%
e	120037	7.3%
f	80252	4.9%
u	80121	4.9%
l	80078	4.9%
y	79832	4.9%
a	79832	4.9%
m	79832	4.9%
Other values (13)	559779	34.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1639429	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	159953	9.8%
i	159918	9.8%
t	159795	9.7%
e	120037	7.3%
f	80252	4.9%
u	80121	4.9%
l	80078	4.9%
y	79832	4.9%
a	79832	4.9%
m	79832	4.9%
Other values (13)	559779	34.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1639429	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	159953	9.8%
i	159918	9.8%
t	159795	9.7%
e	120037	7.3%
f	80252	4.9%
u	80121	4.9%
l	80078	4.9%
y	79832	4.9%
a	79832	4.9%
m	79832	4.9%
Other values (13)	559779	34.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1639429	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	159953	9.8%
i	159918	9.8%
t	159795	9.7%
e	120037	7.3%
f	80252	4.9%
u	80121	4.9%
l	80078	4.9%
y	79832	4.9%
a	79832	4.9%
m	79832	4.9%
Other values (13)	559779	34.1%

Customer_Email
Text

Distinct	8999
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Memory size	14.9 MiB

Length

Max length	21
Median length	21
Mean length	21
Min length	21

Characters and Unicode

Total characters	4200000
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	customer2148@bank.com
2nd row	customer8393@bank.com
3rd row	customer8594@bank.com
4th row	customer1396@bank.com
5th row	customer1126@bank.com

Value	Count	Frequency (%)
customer5223@bank.com	44	< 0.1%
customer6842@bank.com	43	< 0.1%
customer4526@bank.com	43	< 0.1%
customer7358@bank.com	42	< 0.1%
customer7532@bank.com	41	< 0.1%
customer6718@bank.com	40	< 0.1%
customer4530@bank.com	40	< 0.1%
customer1298@bank.com	40	< 0.1%
customer2562@bank.com	39	< 0.1%
customer3356@bank.com	39	< 0.1%
Other values (8989)	199589	99.8%

Most occurring characters

Value	Count	Frequency (%)
c	400000	9.5%
o	400000	9.5%
m	400000	9.5%
u	200000	4.8%
t	200000	4.8%
s	200000	4.8%
e	200000	4.8%
r	200000	4.8%
@	200000	4.8%
n	200000	4.8%
Other values (14)	1600000	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4200000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
c	400000	9.5%
o	400000	9.5%
m	400000	9.5%
u	200000	4.8%
t	200000	4.8%
s	200000	4.8%
e	200000	4.8%
r	200000	4.8%
@	200000	4.8%
n	200000	4.8%
Other values (14)	1600000	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4200000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
c	400000	9.5%
o	400000	9.5%
m	400000	9.5%
u	200000	4.8%
t	200000	4.8%
s	200000	4.8%
e	200000	4.8%
r	200000	4.8%
@	200000	4.8%
n	200000	4.8%
Other values (14)	1600000	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4200000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
c	400000	9.5%
o	400000	9.5%
m	400000	9.5%
u	200000	4.8%
t	200000	4.8%
s	200000	4.8%
e	200000	4.8%
r	200000	4.8%
@	200000	4.8%
n	200000	4.8%
Other values (14)	1600000	38.1%

Interactions

Correlations

	Account_Balance	Account_Type	Age	Bank_Branch	City	Device_Type	Gender	Is_Fraud	Merchant_Category	State	Transaction_Amount	Transaction_Currency	Transaction_Description	Transaction_Device	Transaction_Location	Transaction_Type
Account_Balance	1.000	0.000	-0.000	0.003	0.002	0.001	0.003	0.004	0.001	0.002	0.001	0.003	0.003	0.000	0.002	0.000
Account_Type	0.000	1.000	0.004	0.003	0.000	0.002	0.000	0.000	0.000	0.000	0.003	0.002	0.002	0.000	0.000	0.002
Age	-0.000	0.004	1.000	0.000	0.000	0.002	0.004	0.000	0.001	0.002	0.000	0.002	0.000	0.000	0.000	0.001
Bank_Branch	0.003	0.003	0.000	1.000	0.003	0.001	0.000	0.000	0.000	0.000	0.000	0.005	0.002	0.002	0.003	0.003
City	0.002	0.000	0.000	0.003	1.000	0.000	0.005	0.000	0.000	0.000	0.001	0.000	0.000	0.004	0.000	0.000
Device_Type	0.001	0.002	0.002	0.001	0.000	1.000	0.000	0.350	0.040	0.000	0.157	0.000	0.000	0.052	0.157	0.000
Gender	0.003	0.000	0.004	0.000	0.005	0.000	1.000	0.000	0.003	0.003	0.003	0.003	0.000	0.000	0.004	0.000
Is_Fraud	0.004	0.000	0.000	0.000	0.000	0.350	0.000	1.000	0.256	0.001	1.000	0.000	0.003	0.255	1.000	0.000
Merchant_Category	0.001	0.000	0.001	0.000	0.000	0.040	0.003	0.256	1.000	0.001	0.114	0.000	0.000	0.038	0.114	0.000
State	0.002	0.000	0.002	0.000	0.000	0.000	0.003	0.001	0.001	1.000	0.000	0.000	0.004	0.004	0.003	0.000
Transaction_Amount	0.001	0.003	0.000	0.000	0.001	0.157	0.003	1.000	0.114	0.000	1.000	0.000	0.000	0.147	0.354	0.000
Transaction_Currency	0.003	0.002	0.002	0.005	0.000	0.000	0.003	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.003	0.000
Transaction_Description	0.003	0.002	0.000	0.002	0.000	0.000	0.000	0.003	0.000	0.004	0.000	0.000	1.000	0.000	0.002	0.003
Transaction_Device	0.000	0.000	0.000	0.002	0.004	0.052	0.000	0.255	0.038	0.004	0.147	0.000	0.000	1.000	0.147	0.003
Transaction_Location	0.002	0.000	0.000	0.003	0.000	0.157	0.004	1.000	0.114	0.003	0.354	0.003	0.002	0.147	1.000	0.004
Transaction_Type	0.000	0.002	0.001	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	0.003	0.004	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Customer_ID	Customer_Name	Gender	Age	State	City	Bank_Branch	Account_Type	Transaction_ID	Transaction_Date	Transaction_Time	Transaction_Amount	Merchant_ID	Transaction_Type	Merchant_Category	Account_Balance	Transaction_Device	Transaction_Location	Device_Type	Transaction_Currency	Customer_Contact	Transaction_Description	Customer_Email
0	CUST000001	Customer_1	Male	25	CA	Los Angeles	Branch B	Checking	TXN000000001	2023-01-01 00:00:00	00:00:00	102.690676	MERCHANT839	Online	Clothing	1760.420524	POS Terminal	CA	Windows PC	USD	+1-240-2997	Gift	customer2148@bank.com
1	CUST000002	Customer_2	Female	58	FL	New York	Branch C	Savings	TXN000000002	2023-01-01 00:01:00	00:01:00	83.034624	MERCHANT50	ATM Withdrawal	Luxury	7833.088780	Web	TX	Android	USD	+1-641-1940	Payment	customer8393@bank.com
2	CUST000003	Customer_3	Female	71	PA	Dallas	Branch A	Savings	TXN000000003	2023-01-01 00:02:00	00:02:00	51.521278	MERCHANT453	ATM Withdrawal	Travel	7239.890561	POS Terminal	IL	Windows PC	EUR	+1-685-4317	Subscription	customer8594@bank.com
3	CUST000004	Customer_4	Female	27	NY	Chicago	Branch A	Savings	TXN000000004	2023-01-01 00:03:00	00:03:00	74.897156	MERCHANT231	ATM Withdrawal	Clothing	4269.744125	POS Terminal	CA	Windows PC	CAD	+1-650-5207	Subscription	customer1396@bank.com
4	CUST000005	Customer_5	Male	28	OH	Philadelphia	Branch B	Savings	TXN000000005	2023-01-01 00:04:00	00:04:00	5.000000	MERCHANT664	Online	Electronics	4877.511195	Web	PA	Linux	CAD	+1-995-5816	Gift	customer1126@bank.com
5	CUST000006	Customer_6	Male	35	IL	Philadelphia	Branch B	Checking	TXN000000006	2023-01-01 00:05:00	00:05:00	64.265487	MERCHANT571	Online	Luxury	6608.633036	ATM	IL	Mac	USD	+1-427-5502	Refund	customer4636@bank.com
6	CUST000007	Customer_7	Male	49	TX	Miami	Branch B	Savings	TXN000000007	2023-01-01 00:06:00	00:06:00	33.407848	MERCHANT49	ATM Withdrawal	Luxury	4070.596903	POS Terminal	IL	Windows PC	USD	+1-534-6600	Subscription	customer8995@bank.com
7	CUST000008	Customer_8	Female	33	PA	Los Angeles	Branch D	Business	TXN000000008	2023-01-01 00:07:00	00:07:00	21.495652	MERCHANT767	Online	Travel	4790.814115	POS Terminal	OH	ATM Machine	USD	+1-676-2700	Payment	customer2414@bank.com
8	CUST000009	Customer_9	Female	74	OH	Houston	Branch A	Savings	TXN000000009	2023-01-01 00:08:00	00:08:00	31.181209	MERCHANT203	ATM Withdrawal	Grocery	2799.823637	Web	CA	Linux	USD	+1-265-6726	Bill Payment	customer6549@bank.com
9	CUST000010	Customer_10	Female	37	FL	Philadelphia	Branch D	Savings	TXN000000010	2023-01-01 00:09:00	00:09:00	21.235605	MERCHANT550	Online	Travel	3511.964463	POS Terminal	TX	iPhone	USD	+1-546-6429	Subscription	customer4352@bank.com

	Customer_ID	Customer_Name	Gender	Age	State	City	Bank_Branch	Account_Type	Transaction_ID	Transaction_Date	Transaction_Time	Transaction_Amount	Merchant_ID	Transaction_Type	Merchant_Category	Account_Balance	Transaction_Device	Transaction_Location	Device_Type	Is_Fraud	Transaction_Currency	Customer_Contact	Transaction_Description	Customer_Email
199990	CUST199991	Customer_199991	Female	31	FL	Chicago	Branch D	Savings	TXN000199991	2023-05-19 21:10:00	21:10:00	713.527806	MERCHANT724	POS	Luxury	5026.085810	Web	Of	Windows PC	1	USD	+1-928-9568	Subscription	customer6942@bank.com
199991	CUST199992	Customer_199992	Female	75	OH	Chicago	Branch C	Business	TXN000199992	2023-05-19 21:11:00	21:11:00	729.985845	MERCHANT32	POS	Luxury	8269.853573	Web	Of	Windows PC	1	USD	+1-911-4172	Subscription	customer6191@bank.com
199992	CUST199993	Customer_199993	Male	69	IL	Dallas	Branch C	Savings	TXN000199993	2023-05-19 21:12:00	21:12:00	805.121697	MERCHANT947	POS	Online Services	7300.610412	Web	Hi	Windows PC	1	EUR	+1-244-4245	Bill Payment	customer4778@bank.com
199993	CUST199994	Customer_199994	Male	44	TX	Dallas	Branch C	Savings	TXN000199994	2023-05-19 21:13:00	21:13:00	500.000000	MERCHANT21	POS	Travel	5084.616462	ATM	Of	ATM Machine	1	EUR	+1-766-3547	Gift	customer1396@bank.com
199994	CUST199995	Customer_199995	Male	26	OH	Miami	Branch D	Business	TXN000199995	2023-05-19 21:14:00	21:14:00	802.320096	MERCHANT436	POS	Luxury	5592.085149	Web	Un	ATM Machine	1	CAD	+1-696-4653	Payment	customer2891@bank.com
199995	CUST199996	Customer_199996	Female	50	NY	Miami	Branch D	Savings	TXN000199996	2023-05-19 21:15:00	21:15:00	527.962149	MERCHANT32	Online	Online Services	4465.649560	ATM	Hi	Windows PC	1	USD	+1-103-6246	Payment	customer9284@bank.com
199996	CUST199997	Customer_199997	Female	69	PA	New York	Branch B	Savings	TXN000199997	2023-05-19 21:16:00	21:16:00	568.070220	MERCHANT585	ATM Withdrawal	Luxury	2164.251235	ATM	Hi	Windows PC	1	CAD	+1-456-3560	Subscription	customer8558@bank.com
199997	CUST199998	Customer_199998	Male	23	FL	Dallas	Branch A	Business	TXN000199998	2023-05-19 21:17:00	21:17:00	1178.822244	MERCHANT669	POS	Luxury	1739.432350	Web	Hi	Windows PC	1	USD	+1-337-4670	Refund	customer7015@bank.com
199998	CUST199999	Customer_199999	Female	36	FL	Philadelphia	Branch B	Checking	TXN000199999	2023-05-19 21:18:00	21:18:00	1008.643360	MERCHANT677	Online	Online Services	4797.744120	ATM	Hi	ATM Machine	1	USD	+1-537-8714	Subscription	customer2544@bank.com
199999	CUST200000	Customer_200000	Male	36	PA	Dallas	Branch D	Savings	TXN000200000	2023-05-19 21:19:00	21:19:00	789.449699	MERCHANT805	POS	Online Services	3521.334811	Web	Of	Windows PC	1	USD	+1-970-5789	Subscription	customer3550@bank.com

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category